package com.qiaofang.repository;

import com.qiaofang.entity.PremisesDynamicExternal;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;

import java.util.List;

public interface PremisesDynamicExternalRepository extends JpaRepository<PremisesDynamicExternal, Long> {
    @Query(value = "from PremisesDynamicExternal p where p.dynamicId = :dynamicId and p.isDeleted = '0' order by p.id asc ")
    List<PremisesDynamicExternal> listDynamicExternal(@Param(value = "dynamicId") Long dynamicId);
}
